Microsoft Excel
Introduction	Intermediate		Advanced
Getting started Spreadsheet terminology The Excel environment Navigating a worksheet Using a template Entering and editing data Entering and editing text and values Entering and editing formulas Saving and updating workbooks Modifying a worksheet Moving and copying data Moving, copying, and viewing formulas Absolute and relative references Inserting and deleting ranges, rows, and columns Functions Entering functions AutoSum Other common functions Formatting Text formatting Row and column formatting Number formatting Conditional formatting Additional formatting options Charts Chart basics Formatting charts Graphics Working with pictures Conditional formatting with graphics SmartArt graphics Printing Preparing to print Page Setup options Printing worksheets	Managing workbooks and worksheets Viewing large worksheets Printing large worksheets Working with multiple worksheets Linking worksheets with 3-D formulas Using multiple workbooks Linking workbooks Advanced formatting Using special number formats Working with themes Other advanced formatting Outlining and subtotals Outlining and consolidating data Creating subtotals Cell and range names Creating and using names Managing names Data structure and tables Sorting and filtering data Working with tables Web and sharing features Saving workbooks as Web pages Using hyperlinks Sharing workbooks Documenting and auditing Auditing features Comments in cells and workbooks Protection Workgroup collaboration Application settings and templates Application settings Working with templates		Advanced functions and formulas Logical functions Conditional functions Financial functions Text functions Date functions Array formulas Lookups and data tables Using lookup functions Using MATCH and INDEX Creating data tables Advanced data management Validating cell entries Advanced filtering Advanced charting Chart formatting options Combination charts Graphical objects PivotTables and PivotCharts Working with PivotTables Rearranging PivotTables Formatting PivotTables PivotCharts Exporting and importing data Exporting and importing text files Getting external data Analytical tools Goal Seek Scenarios Macros and Visual Basic Running and recording a macro Working with VBA code
Computer Training of America, Inc.	Telephone: (413) 283-7740		Toll Free: (877) 283-7740
Fax: (413) 283-7730		Web Site: www.computertrainingofamerica.com